GrapeCity.CalcEngine.Functions Namespace > CalcWorkdayFunction Class > Evaluate Method : Evaluate(Object[]) Method |
The args contains 2 - 3 items: start_date, days, [holidays].
Start_date is a date that represents the start date.
Days is the number of nonweekend and nonholiday days before or after start_date. A positive value for days yields a future date; a negative value yields a past date.
[Holidays] is an optional list of one or more dates to exclude from the working calendar, such as state and federal holidays and floating holidays. The list can be either a range of cells that contain the dates or an array constant (array: Used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. An array range shares a common formula; an array constant is a group of constants used as an argument.) of the serial numbers that represent the dates.
'Usage Dim instance As CalcWorkdayFunction Dim args() As Object Dim value As Object value = instance.Evaluate(args)
The args contains 2 - 3 items: start_date, days, [holidays].
Start_date is a date that represents the start date.
Days is the number of nonweekend and nonholiday days before or after start_date. A positive value for days yields a future date; a negative value yields a past date.
[Holidays] is an optional list of one or more dates to exclude from the working calendar, such as state and federal holidays and floating holidays. The list can be either a range of cells that contain the dates or an array constant (array: Used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. An array range shares a common formula; an array constant is a group of constants used as an argument.) of the serial numbers that represent the dates.
Target Platforms: Windows Server 2012, Windows RT